/*
 *  mini-SaaS
 *  Application for developing Software as a Service (SaaS) 
 *  Copyright (c) 2011 Anand Sudhakaran, Bryce Holton, Chao Zhang
 *  ASU
 *
 *  This file is part of mini-SaaS.
 *
 *  mini-SaaS is free software; you can redistribute it and/or modify
 *  it under the terms of the GNU General Public License as published by
 *  the Free Software Foundation; either version 3 of the License, or
 *  (at your option) any later version.
 *  
 *  mini-SaaS is distributed in the hope that it will be useful,
 *  but WITHOUT ANY WARRANTY; without even the implied warranty of
 *  MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
 *  GNU General Public License for more details.

 *  You should have received a copy of the GNU General Public License
 *  along with mini-SaaS; if not, see <http://www.gnu.org/licenses/>. 
 *
 */

package loginbean;

import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

public class VerifyCreditCardService {
	public String verifyCreditCard(int tenantid,String CCNum)
	    {
		Connection conn = null;
		Statement st2=null;

			if(CCNum.length()>1)
			{
				DBManager db = new DBManager();
				try {
					conn = db.getDatabaseConnection();
					String strQuery2 = "UPDATE datatable SET Value='" + CCNum + "' WHERE tenantid=" + tenantid + " and fieldid = 17";
					
					st2 = conn.createStatement();
					st2.execute(strQuery2);
					
				} catch (Exception e) {
					
					e.printStackTrace();
				}


				return  
						"<form name='creditCardForm' method='post' action='Result2.jsp'> " +
						"Congratulations! You payment is down.<br/>" +
						"<input type='submit' name='Submit' value='Submit'>" +
						"</form>";
			}
			else 
				return "<form name='creditCardForm' method='post' action='Result2.jsp'> " +
				"The credit card is not right.<br/>" +
				"<input type='submit' name='Submit' value='Submit'>" +
				"</form>";
						
    }
}
